// 封装数据库查询语句
var auother_sql = {
    insertOne: 'INSERT INTO article.auother (username, gender, phone, email, state, role_id, password)VALUES(?,?,?,?,?,?,?);',
    deleteOne: 'DELETE FROM article.auother WHERE id=?;',
    updateOne: 'UPDATE article.auother a SET username=?, gender=?, phone=?, email=?, state=?, role_id=?, password=? WHERE a.id=?;',
    selectOneOrigin: 'select * FROM article.auother a where a.id = ?',
    selectOne: 'select a.id, username,  gender, phone, email, state, r.role_name,password from auother a left join `role` r on a.role_id = r.id where a.id = ?',
    selectAll: 'select a.id, username,  gender, phone, email, state, r.role_name,password from auother a left join `role` r on a.role_id = r.id ',
}
module.exports = auother_sql